﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$UserLoginDBConnection$">
	<Sql>
		UPDATE UserBasicSettings SET
		<code>
			<![CDATA[
			IBizObjList fields = App.ruleMgr.execute("getUserSettingsDbFields").CallResults as IBizObjList;
			if(fields != null)
			foreach(IBizObj field in fields)
			{
				sql.AppendFormat("{0}=@{0}, ", field.get("dbName"));
				addParameter(cmd,(string)field.get("bizObjName"), (string)field.get("dbName"),(string)field.get("dbType"), info);
			}
		]]>
		</code>
		userId=@id
		WHERE userId=@id
	</Sql>

	<Param name="id" type="UniqueIdentifier"/>
</AdoNetDataAccess>
